SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_SearchLink]
    (
      @JOL_Link_Title VARCHAR(100)
    )
AS 
    SELECT  JOL_Link_No,
            JOL_Link_Title,
            JOL_Link_Type,
            JOL_Link_Website,
            JOL_Link_ImageUrl
    FROM    dbo.JOL_Link
    WHERE   JOL_Link_Title LIKE '%' + @JOL_Link_Title + '%'
    ORDER BY JOL_Link_AddTime DESC,
            JOL_Link_UpdateTime DESC

GO
